Stats for: 2018-09-10

SELECT timestamp, SUM(today), SUM(total) FROM github_traffic GROUP BY timestamp ORDER BY timestamp ASC;

SELECT timestamp, today, total FROM github_traffic WHERE repo='FogLAMP' ORDER BY timestamp ASC;

SELECT timestamp, today, total FROM github_traffic WHERE repo='foglamp-gui' ORDER BY timestamp ASC;

SELECT timestamp, SUM(today), SUM(total) FROM github_clones GROUP BY timestamp ORDER BY timestamp ASC;

SELECT referral, SUM(today) FROM github_referrals WHERE timestamp=(SELECT MAX(timestamp) FROM github_referrals) GROUP BY referral ORDER BY SUM(today) ASC;

SELECT referral, MAX(total) FROM github_referrals GROUP BY referral ORDER BY SUM(today) ASC;